/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : localhost:3306
 Source Schema         : userconfig

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 06/08/2021 16:47:11
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for student_score
-- ----------------------------
DROP TABLE IF EXISTS `student_score`;
CREATE TABLE `student_score` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `student_id` bigint(20) NOT NULL COMMENT '学号',
  `gender_man` tinyint(4) NOT NULL DEFAULT '0' COMMENT '性别, 0:女; 1:男',
  `school_term` int(11) DEFAULT NULL COMMENT '学期',
  `subject` varchar(30) DEFAULT NULL COMMENT '学科',
  `score` int(11) DEFAULT NULL COMMENT '成绩',
  `gmt_create` datetime NOT NULL COMMENT '记录创建时间',
  `gmt_modified` datetime NOT NULL COMMENT '记录最后修改时间',
  `is_deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '逻辑删除标识',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of student_score
-- ----------------------------
BEGIN;
INSERT INTO `student_score` VALUES (1, 2020001, 0, 1, '语文', 90, '2021-08-06 14:46:01', '2021-08-06 14:46:04', 0);
INSERT INTO `student_score` VALUES (2, 2020002, 0, 1, '数学', 80, '2021-08-06 14:46:34', '2021-08-06 14:46:37', 0);
INSERT INTO `student_score` VALUES (3, 2020003, 0, 2, '语文', 99, '2021-08-06 14:46:58', '2021-08-06 14:47:03', 0);
INSERT INTO `student_score` VALUES (4, 2020002, 0, 2, '数学', 79, '2021-08-06 14:47:38', '2021-08-06 14:47:40', 0);
INSERT INTO `student_score` VALUES (5, 2020001, 0, 2, '语文', 90, '2021-08-06 14:48:05', '2021-08-06 14:48:08', 0);
INSERT INTO `student_score` VALUES (6, 2020001, 0, 2, '数学', 78, '2021-08-06 14:48:28', '2021-08-06 14:48:38', 0);
INSERT INTO `student_score` VALUES (7, 2020003, 0, 2, '数学', 97, '2021-08-06 14:49:00', '2021-08-06 14:49:02', 0);
INSERT INTO `student_score` VALUES (8, 2020002, 0, 1, '语文', 79, '2021-08-06 14:49:21', '2021-08-06 14:49:23', 0);
INSERT INTO `student_score` VALUES (9, 2020003, 0, 1, '语文', 98, '2021-08-06 14:50:22', '2021-08-06 14:50:24', 0);
INSERT INTO `student_score` VALUES (10, 2020003, 0, 1, '数学', 99, '2021-08-06 14:50:50', '2021-08-06 14:50:52', 0);
INSERT INTO `student_score` VALUES (11, 2020002, 0, 2, '语文', 93, '2021-08-06 14:51:30', '2021-08-06 14:51:32', 0);
INSERT INTO `student_score` VALUES (12, 2020001, 0, 1, '数学', 89, '2021-08-06 14:51:52', '2021-08-06 14:51:54', 0);
INSERT INTO `student_score` VALUES (13, 2020004, 0, 1, '语文', 90, '2021-08-05 14:46:01', '2021-08-05 14:46:04', 0);
INSERT INTO `student_score` VALUES (14, 2020006, 0, 2, '语文', 99, '2021-08-05 14:46:58', '2021-08-05 14:47:03', 0);
INSERT INTO `student_score` VALUES (15, 2020004, 0, 2, '语文', 90, '2021-08-05 14:48:05', '2021-08-05 14:48:08', 0);
INSERT INTO `student_score` VALUES (16, 2020005, 0, 1, '语文', 79, '2021-08-05 14:49:21', '2021-08-05 14:49:23', 0);
INSERT INTO `student_score` VALUES (17, 2020006, 0, 1, '语文', 98, '2021-08-05 14:50:22', '2021-08-05 14:50:24', 0);
INSERT INTO `student_score` VALUES (18, 2020005, 0, 2, '语文', 93, '2021-08-05 14:51:30', '2021-08-05 14:51:32', 0);
INSERT INTO `student_score` VALUES (19, 2020005, 0, 1, '数学', 80, '2021-08-05 14:46:34', '2021-08-05 14:46:37', 0);
INSERT INTO `student_score` VALUES (20, 2020005, 0, 2, '数学', 79, '2021-08-05 14:47:38', '2021-08-05 14:47:40', 0);
INSERT INTO `student_score` VALUES (21, 2020004, 0, 2, '数学', 78, '2021-08-05 14:48:28', '2021-08-05 14:48:38', 0);
INSERT INTO `student_score` VALUES (22, 2020006, 0, 2, '数学', 97, '2021-08-05 14:49:00', '2021-08-05 14:49:02', 0);
INSERT INTO `student_score` VALUES (23, 2020006, 0, 1, '数学', 99, '2021-08-05 14:50:50', '2021-08-05 14:50:52', 0);
INSERT INTO `student_score` VALUES (24, 2020004, 0, 1, '数学', 89, '2021-08-05 14:51:52', '2021-08-05 14:51:54', 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
